Model Table VIM SERIAL
This model dimension represents the Serial Structure Information, part of
Vehicle Information Management, and is based on the IFS Cloud dimension
DIM_VIM_SERIAL. All models that refers to this dimension will have the attributes
and hierarchies as described below.
Attributes
| Attribute | Description (where applicable) |
| Eng Part Revision | Part revision for the serial |
| Location Code | Location Code for the serial |
| Maint Group | Maint Group Code |
| Maint Group Desc | Maint Group Description |
| Maint Prog Id | Risk Consequence ID - Consequence
Description |
| Maint Prog Rev | Maint Prog Revision No |
| Manufactured Date | Article Manufacturing Date |
| Manufacturer | |
| Manufacturer Name | |
| Manufacturer Part No | Manufacturer's article number |
| Operational Condition | Operational Condition |
| Operational Status | Operational Status |
| Owner Desc | Owner Organization Description |
| Owner Org | Owner Organization Code |
| Owning Customer No | Owning Customer Code |
| Part Desc | Part Description |
| Part No | Part Number |
| Part Ownership | Type of ownership description |
| Quarantined | Quarantined TRUE/FALSE |
| Serial No | Part Serial Number |
| Structure Address | Structure Position Address |
| Template Part No | Template Part Number |
| Template Part Rev | Template Part Revision Number |
| VIM Serial | Partno + Serial No +Part Description |
| Vehicle Id | Vehicle Id |
| Workshop Code | Workshop Code |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| VIM SERIAL | DIM_VIM_SERIAL_TM | DIM_VIM_SERIAL_BI | DIM_VIM_SERIAL | On Line |